-- =========================================
-- Author: Jacob Gable
-- Created: 02.00.2009
-- Notes: Creation of ExerciseLookup table.
-- 
-- 
-- =========================================

IF OBJECT_ID('dbo.ExerciseLookup', 'U') IS NOT NULL
  DROP TABLE dbo.ExerciseLookup
GO

CREATE TABLE dbo.ExerciseLookup
(
	ExerciseId int identity(1,1) NOT NULL, 
	BodyArea nvarchar(255) NOT NULL, 
	[Name] nvarchar(1000) NOT NULL, 
	ts timestamp NULL,
    CONSTRAINT PK_Exercise PRIMARY KEY (ExerciseId)
)
GO
